SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003701s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421061 LIMIT 1 [ RunTime:0.001938s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421061 [ RunTime:0.009766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182717,560192,448398,920900,410050,130685,234670,439958,334557,1044952,69971,813502,261585,1046566,3757,383730,995995,868111,41808,516994,214558,664872,212121,117780,578897,141002,76905,935416,337853,579051,125778,25222,452877,947618,867098,404879,950754,422880,905102,117669,52847,706645,188431,364278,239456,327908,300220,300436,564768,254342,133259,346958,837745,993490,641014,544091,600351,865518,299560,222409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003065s ]