SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324820 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324820 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406301,1008220,479874,533251,320867,883669,457444,767715,245033,12588,496421,721643,52059,318029,1015241,956840,539322,746496,254676,109244,274495,593737,48610,958934,382066,690677,295943,182818,409881,300934,649490,878039,935248,820438,468517,668802,501377,697307,131603,52979,263647,762382,315324,232072,752195,1024010,621383,68720,957249,511282,279561,1027987,615828,637564,945792,1028641,52035,128416,381093,501725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]