SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195488 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195488 [ RunTime:0.002772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847712,121575,337106,1012014,168870,333197,223327,706659,771941,734360,659581,658967,19690,209415,620114,546960,923443,376342,348077,144224,251092,655158,840297,429893,56903,445123,791738,21544,704751,969285,300192,722694,231989,569424,601899,522457,23119,509144,405262,294083,218891,683504,850448,325603,128291,332368,882996,153717,728941,690650,19305,681450,136681,444231,692313,56169,184378,997028,233412,840280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195488 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195488 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]