SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004730s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465046 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465046 [ RunTime:0.009774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754640,452975,992907,767629,544322,698554,360437,103441,847251,82708,461516,968970,436140,452811,275266,870432,1012995,282134,274181,130222,600128,333537,142533,603735,331010,785291,202702,802045,197651,279029,556471,718107,152255,605768,113737,322034,895968,725337,792401,928621,385683,582513,14559,125376,532757,83450,895099,178021,1002030,496788,763381,575433,831297,341678,784428,91185,530375,755879,84542,1016777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]