SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024220 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024220 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412068,214271,347028,468232,349265,350309,716902,753166,47055,1020743,932287,610457,238803,450368,659499,76103,234580,843064,120252,137947,975358,821283,173050,266736,379674,1043020,854165,219405,128523,1028147,86636,854712,481815,296057,280084,25451,129139,673704,257983,70536,845853,965171,610814,378037,1023306,216152,583698,544985,890511,992715,71443,663584,265099,85291,35430,663653,1020196,188096,651726,608020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]