SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442010 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442010 [ RunTime:0.005730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (725158,187692,540551,394619,424839,537265,610561,95123,847812,976548,107244,417267,24915,49258,905573,176756,522279,920332,887378,21344,379167,288149,539423,12838,385529,32298,345122,1029537,471739,631712,357607,386485,545540,496082,380078,962254,614486,771710,430668,139597,720371,985495,1001346,572950,705373,1016207,877546,43729,837739,665003,125836,118162,826559,945002,1047770,270039,374458,1022172,448867,717455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]