SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41018 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41018 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682648,807459,862900,628037,331883,555327,149198,183108,899042,160548,833329,453916,28568,432255,372746,792309,856459,566181,772246,453873,1023247,894645,473473,686565,21746,243907,196775,701997,135612,727849,980268,729651,824624,846558,184351,891772,912415,729531,1026334,432708,747732,714483,816165,356538,508010,574710,419995,928797,591244,728455,899934,834695,286527,457585,299430,934747,496658,127145,743162,119167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001317s ]