SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001502s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446071 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446071 [ RunTime:0.004210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635610,825909,774342,76044,746980,639168,759754,488435,871376,92074,459483,124894,610471,709201,713425,924638,69972,271120,37346,498572,105150,372706,634796,322583,34572,301079,18440,1042002,265414,31573,465231,668119,299748,102680,692212,413550,912120,253299,11790,753252,848436,252583,471532,615179,134494,1009954,83428,1017933,251523,429879,246226,858827,536747,296161,554627,958252,938937,769220,948761,786537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002769s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000719s ]