SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20031 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20031 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635160,1018087,583548,628604,951525,194147,459828,216712,672875,561811,542826,381241,269266,749916,83193,817487,458163,932051,787295,603660,549308,124191,1031381,930494,692633,572278,406616,685832,1023845,188394,180601,556161,458685,631649,628882,152199,63005,388892,847484,107627,671935,261740,135060,568808,471249,484377,341834,798788,876993,35523,967204,742050,418623,710714,139196,474764,493088,960593,31929,50130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]