SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 956696 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 956696 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212846,379884,964346,195060,944881,121676,828330,824434,542215,482349,564942,11435,12352,43953,509516,280135,375461,447543,186670,114033,598874,682160,447223,569648,358080,212267,544891,650078,801821,111085,667026,526027,906811,1011366,736480,955947,105500,229849,897801,714008,279220,99240,674746,436049,89006,916642,299378,463838,1021881,859330,331692,69418,569961,338022,774790,341696,961125,55652,87123,594515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 956696 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 956696 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]