SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344822 LIMIT 1 [ RunTime:0.001135s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344822 [ RunTime:0.002560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251981,879671,791436,301496,986901,648411,758824,172635,972448,681581,38202,656297,1045351,451958,103083,393719,784719,213378,364592,901633,671350,580730,1024366,9014,433194,458081,224600,758471,594989,1013617,916297,89796,533138,47461,527524,996413,216490,1047596,500527,311313,52925,411120,559437,919717,622955,907199,45237,524437,740006,350136,533849,509934,323745,508388,769450,984362,288708,859979,104824,142167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]