SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001958s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 604160 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 604160 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964540,250528,748152,111604,125078,691296,449878,491797,747473,840279,20890,887748,664485,952242,445683,791753,332220,567946,310729,1009784,287598,379707,349517,192684,110558,674529,964101,353337,696067,214783,964018,407896,821357,713544,250046,401555,512196,476703,1036978,25280,520302,892395,807895,705042,585247,1011425,663316,826806,175939,525950,557423,619323,911123,584172,385945,656726,1043207,500778,484044,889328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 604160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 604160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]