SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045946 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045946 [ RunTime:0.002432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920751,341366,364303,510900,826246,111653,248804,1046360,166075,378776,847300,741050,142203,299590,864099,1019823,797617,705486,958631,317061,526051,302074,379960,240124,426016,326600,279851,638288,106691,350404,707213,909629,215875,191497,81202,53793,299931,766760,453839,304237,371459,140195,917829,137868,397203,642531,301473,176351,325896,195961,88500,936758,345918,904976,111464,1025894,654033,558013,969567,697969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]