SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455071 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455071 [ RunTime:0.002272s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646645,522580,746325,1017164,628599,236334,935013,549563,583464,426700,408068,837534,983088,140087,514950,799374,285377,81113,56057,258502,244818,115428,752365,911381,1023786,994337,269512,228568,892536,182275,728143,106460,105547,183527,292775,812352,435440,131332,603611,911293,904950,859140,580346,695636,261109,794172,376080,1001076,246671,709809,599074,265003,962271,858349,239934,429646,732603,804201,712238,816610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]