SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026041 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026041 [ RunTime:0.002168s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860245,107564,141118,924008,58745,87479,771569,274550,988326,444558,471327,79283,791066,949089,490048,340210,621152,1038789,698690,231126,785931,482349,447958,731059,329145,390636,523072,611046,752576,377403,495157,380905,93433,247904,479584,512881,750606,845513,798225,866023,916237,67874,315333,1020834,355966,839816,765784,860722,937211,106703,968123,1030879,217621,66287,36214,878936,1047215,132054,89065,703399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]