SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 654612 LIMIT 1 [ RunTime:0.000589s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 654612 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037837,770508,450143,388151,483151,481059,906699,1037275,134755,92226,536204,515116,159222,391183,451636,510704,10401,597128,992553,848650,754857,826671,562784,340959,688550,205622,315441,672471,201181,32877,918736,617003,354901,574925,147100,578810,1031286,713101,13410,978991,916986,350383,679551,423024,828474,992870,231729,257952,688088,405910,716683,515155,730830,460646,57244,1022921,58080,730320,243061,257882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 654612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 654612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]