SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428178 LIMIT 1 [ RunTime:0.002759s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428178 [ RunTime:0.011539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306290,867149,434665,131694,408731,116917,940079,996323,863626,540372,832331,296778,384702,88111,511413,95456,13597,470599,955957,894821,537408,730819,904601,908977,135210,400180,753013,736780,439911,770991,564648,206783,1038355,184138,662068,481311,170794,975827,551354,312515,57974,325025,581861,42938,869457,1012208,290493,34623,874085,505379,763965,165389,1008238,747917,372133,564418,811195,132837,854894,9956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003894s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000764s ]