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` = 1010986 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010986 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518313,489133,819897,735654,298420,803110,905891,334108,604677,800530,97883,823001,927900,1031862,221779,884882,696493,572640,365167,469721,552944,346848,336275,503095,839161,70276,888898,167827,513302,107131,122472,894196,248607,1026311,944761,144740,102305,333406,206189,994525,899381,1047829,1019016,466193,927091,1004923,443436,264337,263811,653554,1004000,516450,28677,521619,12496,724911,156722,418067,119667,1036709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001710s ]