SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42062 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42062 [ RunTime:0.002321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36623,595042,1034540,967981,1022847,387709,523829,678834,364666,1021419,553454,352879,576575,379982,511232,107716,820922,491199,697709,434518,542409,318720,44873,797903,537160,970788,61211,419240,526262,664738,881994,131536,432825,275628,644134,1012531,118117,641504,21061,268425,731876,28878,221625,57965,426086,286517,867478,12859,835508,1016584,269131,958066,538193,480588,705219,723990,194010,153773,694414,771221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42062 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42062 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]