SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020683 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020683 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (834169,823011,1030395,986003,585857,981691,998235,413049,931935,757988,418919,121385,904516,602152,359028,240368,194503,79346,293744,136107,926573,306847,850650,1019508,914816,486432,981887,827146,244829,512555,831428,282269,54822,963316,817422,546049,169739,412687,774440,656959,288805,748402,867217,447303,124226,353301,579585,114390,534995,740635,425272,360505,570722,202703,841709,915030,1043033,767780,48635,396433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]