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` = 388315 LIMIT 1 [ RunTime:0.001535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 388315 [ RunTime:0.002668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269482,1043111,728683,245897,717125,382294,809347,32898,548346,729630,472990,1036204,593428,613107,471294,193207,699399,727533,480067,511644,949806,881842,524404,4574,588665,936473,777892,891848,758926,344341,539279,532926,211083,951702,1004804,570811,498755,831517,909825,880622,595925,875677,728158,253445,813485,855663,569503,924006,307493,467889,145820,29480,665472,762831,554848,874417,725872,458059,842280,283606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 388315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 388315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000362s ]