SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310539 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310539 [ RunTime:0.002167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482988,242932,886099,474141,988206,924021,860835,363119,742560,866133,857047,284648,88368,58885,746130,304719,843529,442279,775641,1009402,3367,228062,286914,760197,827631,1015,405415,944812,3715,98241,1047319,361420,697558,97000,935571,713763,599223,937095,404191,74512,622875,26336,19175,296710,736827,658476,89190,1040190,394035,587374,438457,1045484,156637,771504,777442,878173,1045202,240969,244078,963889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]