SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001997s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575652 LIMIT 1 [ RunTime:0.001046s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575652 [ RunTime:0.002736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003951,309989,578409,1023863,183817,881034,232890,1010731,243836,267526,975824,363715,147990,710050,506421,974895,701129,802121,362132,778192,928181,749321,115450,33914,991791,247471,266280,60882,477456,76652,108458,857481,218008,137770,807528,3059,474218,584671,471334,192345,889614,401526,275202,81975,802595,972551,70956,1020690,58224,759526,204715,765018,651677,845029,460499,588159,154474,180903,876536,294445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575652 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575652 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]