SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 11501 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 11501 [ RunTime:0.002695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69163,511059,107180,767074,503398,379008,639095,526327,888877,256584,994810,1007168,775708,89965,223819,58101,69790,401725,274013,221796,391961,1029985,200677,872652,817767,861890,992428,101255,1019519,227539,550728,769642,1008762,28949,605800,118737,596709,376587,188203,255037,1032629,2675,382630,607786,974737,1014387,265518,555289,274905,404179,1033568,377185,793878,781599,39911,787489,591190,99030,103277,1036723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 11501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 11501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]