SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005020s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468915 LIMIT 1 [ RunTime:0.002408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468915 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198209,807145,713982,882711,726444,44841,429075,706758,507818,951608,57148,1020501,183838,758036,1009205,393320,879363,638071,41550,377913,986702,566669,40558,619355,737497,96248,323770,996626,66396,80394,247909,184415,706667,324183,630283,18178,274177,779875,778981,1017088,256231,126067,1037259,671850,574195,907291,202584,317285,976941,351925,502477,497719,279984,798949,435934,223694,23686,130971,830412,12996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]