SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109721 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109721 [ RunTime:0.002341s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664653,517792,338593,953926,866650,283091,461439,100910,618186,829525,547558,796077,359337,610770,832057,999606,346555,594188,242057,8102,529749,60312,251439,959942,504467,165650,1002984,713165,59199,141388,854761,507710,990324,379386,77413,134712,978565,738769,577085,470557,990714,4874,865944,781996,553574,585054,373197,472846,946911,128097,716756,126887,640375,132219,83182,823525,688998,802950,274280,711558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]