SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469506 LIMIT 1 [ RunTime:0.000495s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469506 [ RunTime:0.003407s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3001,502215,823729,182141,853560,761513,796943,168753,910025,770017,562683,936224,281439,750163,400504,425835,182758,617488,72638,82500,402871,596617,777557,321061,144253,515710,286316,199161,601729,386463,604111,184387,422815,75704,702989,961885,971558,630313,434849,849417,986077,254098,499172,719307,168787,833973,43558,571243,734427,336096,793746,634332,229739,351618,852625,502585,975644,270483,95614,29367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.019035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002788s ]