SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 135711 LIMIT 1 [ RunTime:0.003454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 135711 [ RunTime:0.007158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131381,426582,225543,509417,126047,772538,344202,903131,659709,155747,292419,215847,195916,543299,476817,477073,929914,728536,770837,1035441,940493,376131,553701,119146,980981,26638,905518,813172,499993,119993,154129,117581,112948,967020,8891,513524,897667,472675,412120,288013,140462,800516,278534,174289,649883,204146,868925,455771,260481,300401,975658,462339,24735,274994,265236,183076,1045920,1023690,136204,711875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 135711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 135711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]