SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034777 LIMIT 1 [ RunTime:0.001301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034777 [ RunTime:0.002496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486871,218131,366449,61159,551989,647029,760465,133564,66341,675853,196461,299207,88065,162010,730357,32159,669148,289039,460522,660022,136430,643765,409235,50340,546369,705559,528866,995060,755248,465766,580254,91891,74272,450067,329807,494983,393788,2176,4059,1033233,326845,167395,721242,629047,582627,783858,340961,807664,281064,801190,408700,350034,60371,889756,328995,237134,479521,824249,469037,310693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034777 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034777 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002820s ]