SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586309 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586309 [ RunTime:0.002111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44992,236776,243873,96376,208573,479549,430239,699603,889154,159346,1046527,985245,577754,233349,1021624,150521,230738,795147,835687,325369,23284,168914,492001,305612,461011,728519,929428,970451,691685,127668,9213,698446,756594,112052,204073,283973,270790,132996,734226,708474,934473,488079,669952,844229,163678,887958,295416,759988,347596,548262,732674,562655,939120,794607,370608,922744,976521,657822,405903,594968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]