SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516300 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516300 [ RunTime:0.005629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685921,585796,47105,537595,910015,618455,247967,111263,285787,366059,170627,546723,708995,71523,679977,470050,890835,341854,429118,830131,320419,749269,670563,756905,139985,369762,993426,857555,313009,419528,1047110,236548,883491,847144,192592,974480,337871,520308,56956,394493,673854,751351,695645,121440,934946,1018538,935962,150622,686035,588147,212108,641984,158859,171134,667067,982542,503797,1017504,569961,344442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]