SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460823 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460823 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101640,564524,332664,281583,1003744,20918,1039936,1037462,41286,577442,278232,320586,353960,847283,282606,751686,105286,975972,618620,343730,1019001,486136,434269,509699,683051,580161,558491,266334,241397,991274,512099,1018752,284030,150843,52511,621358,870557,293615,861159,394347,590338,574360,696451,415171,263598,312674,755191,136161,833544,566139,336606,719461,784526,1030261,427889,532859,305636,574480,847701,619260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]