SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481234 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481234 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348534,860525,72173,591623,718549,610774,250728,161088,1000245,510500,855299,262598,943346,263112,62275,360156,793218,163922,726143,403662,716680,199351,19630,967356,718379,368352,805698,59606,483386,1025349,889800,520293,414834,466539,56754,23224,604163,642520,846722,775320,650333,1023599,307332,54233,769386,410820,940153,685108,962364,565462,699340,1040041,206830,167063,31920,1039971,257167,656034,814536,463621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001858s ]