SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026201 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026201 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513343,398254,912257,796690,629489,418841,371585,1040776,206148,542439,944141,781098,378265,310302,875820,167172,245246,189756,819863,941488,566084,28996,941924,164314,341265,41241,195336,400576,468579,148815,682452,464776,977249,702999,2065,1026289,132587,758101,1045588,92291,3333,343446,211681,1020910,281993,50879,221855,168571,69374,462976,344933,990463,843393,454959,819232,495700,409189,518983,376998,1003383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]