SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396843 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396843 [ RunTime:0.002376s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028050,681212,205608,293882,865720,146249,187631,944628,1008570,750891,30051,1015796,637978,1021805,223996,14751,525307,107148,456480,490545,320448,141177,305413,594279,320472,1004197,827918,339463,118611,693724,630450,526690,754586,252282,695068,492863,169762,877488,383133,414398,581367,81801,403283,616644,278945,161744,391749,68660,1009254,528601,373449,382788,659898,1034178,493573,22432,303453,365199,917771,454664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]