SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002409s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479421 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479421 [ RunTime:0.002140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218017,621663,452675,266686,421054,326158,738051,483468,513383,158885,181017,856657,117983,919335,372573,1014380,91869,70720,98411,541222,148030,2192,432202,157513,309076,72054,101184,146457,903648,758024,1046362,147168,944148,808643,234957,490649,419091,384991,26229,642595,430814,459408,585028,136616,28045,1030688,810319,1047333,454717,531921,291795,666573,335910,587162,601848,71809,16592,240699,580855,507784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001227s ]