SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 731096 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 731096 [ RunTime:0.002086s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61227,128633,874489,712007,1017741,1021102,958275,598802,209274,273423,462430,892055,1019068,496458,579098,346420,894400,662072,321440,765328,693537,159568,659383,612403,84979,797522,605787,520447,690642,136774,454963,121874,155265,603841,993007,937566,464148,666051,375841,721780,484721,346638,463190,644340,542468,558743,519298,717524,511613,619977,418762,578750,557544,528545,853251,386616,397993,799704,433866,581471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 731096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 731096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000360s ]