SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 166300 LIMIT 1 [ RunTime:0.000604s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 166300 [ RunTime:0.001439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346291,550831,1041154,968352,283944,281357,863916,35660,285900,720516,927527,868712,1030842,91021,25492,448580,740993,546160,794250,641341,109090,382527,932333,222,56852,502769,328209,54088,963824,618724,222557,95232,667972,894379,962318,524740,47758,840480,512734,214206,414598,189423,669552,400671,1013016,871860,741176,328504,594140,850805,675148,215771,711600,176229,486533,548989,1007856,75568,358403,394286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 166300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 166300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]