SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001514s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420321 LIMIT 1 [ RunTime:0.002381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420321 [ RunTime:0.003753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343679,987017,337840,1033683,138198,340957,16827,780096,32151,133250,138466,1011103,237758,342461,149332,461129,310407,110406,802857,403544,258752,201214,370002,610815,240223,537928,182708,868849,1007418,936454,952798,64674,306288,108405,732712,228355,4764,7762,523900,807713,370803,383974,759488,117892,478330,126879,841581,865002,919130,791551,651928,925514,639579,619777,595407,459744,11580,17537,665382,449064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]