SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418564 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418564 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334279,336053,155600,710010,412800,1012786,813580,584228,107594,898626,341751,883837,759574,444684,530268,210559,96905,923730,639680,862460,242506,808063,499633,410505,49479,492404,804246,242237,518536,697279,998482,313383,80000,1047159,905272,227291,1018930,959635,547330,352230,170391,769579,1010713,5734,869785,196457,111572,776784,240932,16415,116458,535064,302519,144581,824292,140061,1038084,64565,972554,144225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]