SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478160 LIMIT 1 [ RunTime:0.000963s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478160 [ RunTime:0.005416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603703,509145,361587,115988,202531,768024,694184,921541,941593,733007,425498,297143,522529,150968,182597,81943,235395,63610,273899,32013,868853,16377,527686,921072,456190,444287,988292,657043,102545,636344,456834,131400,482034,406427,617816,40387,437253,445537,917461,499805,890249,149951,878354,297201,284592,407044,220087,1042724,630355,262813,674462,322595,385212,890586,465262,24819,338213,394464,335025,496660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]