SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 590191 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 590191 [ RunTime:0.003439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355283,885828,367818,650375,461283,579758,23646,912682,520630,385460,217800,821559,340937,955327,647190,992931,942765,900499,121517,900144,501343,724330,1014020,310106,759368,743152,292360,742769,241218,842780,93143,18960,507941,130298,50188,98549,680416,491461,341281,460252,474891,355604,481554,217337,242585,604313,412821,864716,399565,306156,563506,314887,130393,538305,131953,46963,195213,805067,110765,577479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 590191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 590191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]