SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478328 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478328 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424339,22282,453665,560337,545425,123688,224319,461393,937451,165515,347381,587411,511469,238486,692428,412559,982006,379648,819346,561806,807014,147374,866552,973384,343574,445966,197223,137831,84540,23622,428402,192760,712976,429027,639916,58148,294944,940217,476908,373084,904691,748516,517122,50953,859330,744151,233531,910742,588909,182852,452273,584258,904737,470644,133686,463579,840355,579150,189578,995029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003945s ]