SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014264 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014264 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4030,366346,596148,342508,780717,758115,305204,518805,264195,488969,538036,725799,337983,235654,726000,760208,945998,166622,40549,874058,975163,595531,710361,656525,846274,325280,553437,205594,553757,61696,293303,286691,255490,237397,75362,203323,142042,980796,926595,587015,288653,778684,210907,266839,529488,98660,60511,50409,401473,467018,408335,998879,89101,544978,821064,784121,1039875,181761,638196,774196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014264 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014264 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]