SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003579s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476710 LIMIT 1 [ RunTime:0.000894s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476710 [ RunTime:0.003920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (361111,33365,321076,441187,313358,574865,164592,688405,946585,1026834,170573,481980,838745,814871,722523,383194,709242,16690,1015104,393951,681979,103756,562083,311,120157,918988,366946,955841,968639,74993,316155,465628,220988,699222,555241,291026,994362,395215,778419,206001,883202,605876,103390,768772,604460,129160,956392,624110,932410,890429,972219,731916,232772,288973,289580,744585,72717,878138,604349,174051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001906s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]