SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398011 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398011 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199058,332958,330401,590478,958823,270499,633861,750684,945520,742292,100201,711751,987894,19382,98651,411710,185155,977680,182228,28035,342166,677981,1030652,18427,682967,207811,96724,682993,724354,274001,157903,79035,1016520,516364,385804,819823,454946,267088,653775,773436,941711,59884,973977,835658,50691,102967,1021034,74938,553712,330406,90018,88384,253976,278003,435430,241447,854059,560213,510446,550929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000361s ]