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` = 501886 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501886 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568361,41615,65704,381113,362972,533241,202229,663136,106791,721636,382328,407013,586736,784956,880406,508719,789420,794819,268788,91861,751419,577175,911140,1018042,643489,651110,445314,581285,162708,841820,470693,645247,178445,453715,411335,461476,976067,83003,851853,474158,67695,143800,503973,920381,925455,68932,259382,117394,645781,581704,600746,12074,160332,373477,479240,909627,159635,685816,970406,758040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501886 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501886 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]