SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451335 LIMIT 1 [ RunTime:0.001134s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451335 [ RunTime:0.002077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020853,579217,406588,542897,281965,223766,119983,424843,794746,715523,949600,1004034,1040660,922914,857357,743023,489157,277846,451221,773410,848895,384400,173172,579585,500532,573891,524082,1030521,561649,639395,953986,480227,261417,148035,33925,254340,510702,953780,141295,57132,661125,792126,311323,812539,155121,674758,968111,1033410,816225,586262,479664,156495,579620,482404,308384,547083,677512,697674,269454,104895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001378s ]