SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025644 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025644 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855019,1041387,91580,414856,978487,219970,664165,269492,21050,155834,766639,89192,910866,249467,112979,995298,305693,444446,78966,121859,840062,634286,159303,514725,239527,978248,252208,236278,1012735,1047941,383144,1046709,678925,920076,126856,384766,252597,167366,158777,969114,400095,898592,919154,878324,197541,347192,815534,323646,995918,1041087,305711,247224,841800,780797,322155,748278,529314,769255,1032648,948443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000891s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000819s ]