SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445301 LIMIT 1 [ RunTime:0.002361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445301 [ RunTime:0.005804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452866,73015,148679,818570,329891,255185,327901,573356,566073,418200,381312,380500,293448,31755,76126,46503,392820,650006,250518,448884,846198,221613,286850,405206,589179,973839,412884,367890,428927,1024330,320022,642924,652588,282014,919280,570481,395115,841454,750553,76996,130740,938218,543680,662079,775809,26504,1025979,85669,1023281,548039,822358,81491,1038111,898444,122362,406090,851595,671938,208875,726891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]