SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409971 LIMIT 1 [ RunTime:0.000839s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409971 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663973,743383,20059,659758,278305,487958,857904,687426,491922,50505,139184,643427,181950,778504,638345,307380,105954,849547,109218,85997,831853,931883,447131,51312,368098,984551,908476,94037,99280,458421,970932,428723,756300,267148,345021,423291,150842,210102,250188,353307,632862,806326,720223,21132,259496,685527,913200,82152,702707,714215,1022728,328395,75561,87188,499882,702835,707197,126505,6532,2538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]