SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510889 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510889 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540594,85219,666774,26359,876011,1004206,553878,323481,976082,898011,780926,813787,707532,652482,608955,426445,240095,394262,322175,335921,572308,122874,45569,280384,457137,706084,141580,382980,318456,340942,852365,1017633,631400,405839,642803,383198,521779,843001,716221,354724,758639,239874,937209,515359,684293,178543,296451,387720,717520,785648,1038704,95379,254000,890051,800864,980486,399054,543217,905798,890589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510889 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510889 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]