SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310535 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310535 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179322,596037,494672,408836,830967,633779,1046730,373993,235077,982209,640055,792482,427815,641005,92255,162807,172313,629607,307522,884399,602833,60222,886642,60889,611898,1044218,279900,354094,541422,429453,82731,983079,752745,754914,711745,43288,409522,378264,785648,748529,971918,916084,669889,863866,394801,828726,84681,75307,639504,275399,143202,21528,1032080,135860,587662,511190,623322,62138,299941,104492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]