SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804351 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804351 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243032,79193,244397,749623,753746,656150,914204,1023835,600677,624298,891958,745833,962516,141408,685950,861630,96223,381521,502669,474185,785232,188933,831163,618300,530896,811681,266825,1044621,706963,63860,198844,268443,335797,652383,1048171,987613,425511,490299,314831,785716,292944,879627,339890,836470,987688,1034964,1048168,204514,380470,994061,73076,135261,419272,155417,1048224,338960,340781,973274,821497,682293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804351 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804351 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002573s ]