SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522083 LIMIT 1 [ RunTime:0.001305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522083 [ RunTime:0.005673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838645,987478,613661,187727,682689,87593,1000540,717669,476435,788581,426363,957900,423057,732733,487485,550583,533383,723385,484692,689266,672499,435621,432234,205191,992274,94536,23072,653072,829331,731039,1008903,564002,987359,1042560,969121,854275,82090,697164,396216,881073,539027,510128,459955,777463,457268,509283,811257,140091,918567,115568,711791,714124,156550,620395,830425,67154,357712,685594,377938,7395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001431s ]