SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562111 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562111 [ RunTime:0.001519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417814,892706,306745,255287,465509,1036496,569686,395433,668508,957417,128012,626507,525916,499120,87022,718131,981022,647937,105158,10878,826244,58818,991816,280509,666452,353542,608796,711938,100445,888,92683,132882,148450,1759,965086,928384,972728,830225,547148,405227,132333,267939,365944,927268,844605,818265,601984,146218,622956,598409,250608,850209,716537,184626,536949,113005,856762,436874,2279,197654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]