SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 76104 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 76104 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436390,864166,846708,842009,50677,528536,195322,1006658,938972,366279,738071,636289,300820,901507,414712,562300,685663,54043,881848,213243,505090,293453,538877,437736,763743,783867,127957,571891,599152,844821,895538,583007,259471,295232,630305,146095,427433,847515,378400,17675,927734,555754,256594,1018791,786439,886077,20635,143736,959014,873196,40344,854334,557994,277549,385291,635499,1039493,864628,684210,327289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 76104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 76104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]