SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503112 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503112 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728796,522842,536696,923146,1018868,1027808,406111,797771,61653,168686,882259,56897,623903,464017,277143,387908,847850,93705,985501,415920,820520,197184,965143,861407,1043542,746044,738134,314693,372979,301973,926700,960223,95908,71048,876171,631807,781243,46241,910098,276039,998165,22577,612935,803071,450847,595587,934463,1027262,711177,1029493,959448,470286,753572,622997,351509,44029,501918,717516,178771,622147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]