SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104942 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104942 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306095,830355,641966,798615,1022373,338306,449332,793492,9578,394812,572556,784896,551567,472668,129717,778775,754106,364464,663023,10100,227395,918922,329292,285287,377881,756731,842296,548916,1038529,358754,341535,706541,164499,72179,992981,300586,311165,82904,273924,168183,797290,492866,749168,521858,139425,979234,567358,1033389,780757,201621,196415,730663,353052,559006,415084,54568,243563,944714,69947,456470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104942 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104942 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]