SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408680 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408680 [ RunTime:0.002983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436903,385740,38334,865870,745654,905776,480683,975495,874910,211261,617970,32355,510268,34312,623076,450637,317573,606766,708387,917042,451605,382489,779265,777006,946924,198178,584991,743562,976326,494311,572504,508059,929426,652457,181954,907430,123516,473481,712635,823326,219419,892420,941162,638911,903014,759614,1256,604788,794035,463444,292437,247669,719747,469023,1002176,961960,955413,384270,701112,217077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002892s ]