SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479814 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479814 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808049,341059,859589,795740,488350,210704,30976,443979,83511,938441,794107,508966,1007166,478523,688894,137514,91884,802861,344770,658112,51430,861665,60063,170950,391707,605323,555522,787988,404254,135224,455211,485324,485008,752536,415901,101511,441478,292169,220046,429651,641909,494967,925143,732691,514476,356229,969619,467962,189747,976129,405243,561446,4063,348483,968716,925581,613312,465043,35749,300233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]