SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109082 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109082 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499774,418257,11234,408418,491463,345386,230208,714299,391033,780442,473965,224809,492579,40957,44412,325519,604970,479123,955119,886599,596316,390562,252756,506785,466582,615394,882873,685163,782790,847890,761917,853894,393034,567435,39121,747641,252592,401983,922932,3923,86316,245726,1029937,42357,353121,357424,367984,600703,360248,240252,543406,880965,879672,1006464,683807,65312,141584,817611,506945,531059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]