SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420787 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420787 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (363988,484263,1209,292298,453451,940562,869399,200273,56048,681983,400361,921154,618075,888394,256976,811981,555582,241274,714934,537900,500422,826655,953410,957760,44329,578189,3557,1047500,738140,977208,961910,207638,100822,52789,961445,105653,463658,978742,744411,678894,626051,867393,938323,239844,203030,850036,788442,796699,373994,676094,115555,656320,410038,574947,143678,507838,96451,1029189,301872,41109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000880s ]