SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341067 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341067 [ RunTime:0.004829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118101,590734,31072,659161,458005,788726,175874,822418,428184,121556,502137,483163,50550,72304,978068,815425,226927,551929,825149,153643,586323,477848,958648,672525,440836,299857,302760,407013,841594,823707,892850,909655,332510,640765,567195,568839,919123,803451,974967,817911,1015751,1029613,180174,108558,358641,119106,237178,319244,613585,889554,405848,399757,852988,930699,863411,733149,112603,720907,976001,689347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]