SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020591 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020591 [ RunTime:0.002267s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193451,172392,598113,920574,769534,669062,699595,897758,141978,874508,798247,655020,135234,171673,728866,216452,121413,219282,999405,292021,306757,58041,969191,492412,310590,451180,791747,186573,113215,940085,87732,911551,131105,938471,272110,782771,502816,806928,187348,305284,429604,386809,552604,1021907,693770,36763,440715,160698,899104,917931,716219,431385,716281,1020567,631062,556380,310366,249786,288596,270932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]