SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405067 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405067 [ RunTime:0.002084s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568815,1020152,791526,233806,9888,100759,591995,342930,426899,492499,947846,561484,419866,70813,463741,185087,655402,388911,674807,279737,423415,369255,477972,455546,319497,331668,919727,635529,645972,649236,616191,144380,844065,381512,537527,290751,891390,882232,178236,716823,605429,886219,814630,472796,292765,920885,840632,512656,850648,627684,255200,242099,440863,122681,687512,843930,633327,732690,420405,771887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]