SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198659 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198659 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004046,60655,543147,290037,4688,573990,260334,784451,779055,814097,1024413,290273,321832,993975,11079,234936,418000,660271,876178,497272,688376,547625,892723,1005402,670543,65547,712850,674918,683249,782261,243294,883168,870729,432339,286312,415884,963606,395660,644158,890981,571941,621518,640401,896954,490644,44923,681998,212678,427268,830214,410950,165677,39218,1006495,1010774,555265,951041,7438,273126,773877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198659 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198659 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]