SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526012 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526012 [ RunTime:0.003082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204583,805980,297962,589215,513512,162690,555288,829282,490713,218466,690770,509984,617591,221986,608700,941927,972270,450084,661440,1005598,754200,744008,409501,30243,511316,1015137,877173,238103,483673,469218,460769,614960,808967,619931,1027315,378975,384099,209562,981958,499988,95891,884086,279628,519760,646732,815154,55290,883568,520398,744491,2354,171860,806380,535309,817559,376558,580785,662558,936918,59724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]