SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312080 LIMIT 1 [ RunTime:0.000509s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312080 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115425,691394,794343,745747,711726,60658,352804,186266,519688,4918,104613,452873,665794,14564,143873,351606,398646,267557,684198,456287,799028,158862,57358,536023,404870,423809,517356,13836,586559,487583,852997,381506,326417,664585,60209,512340,395311,61621,526353,441037,384070,877598,752069,77749,549636,717529,1021950,591880,469612,278766,441120,53711,922760,374795,870548,839915,825484,931964,637218,848174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]