SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034581 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034581 [ RunTime:0.002319s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371549,372441,776918,142454,374274,103192,595703,753239,921871,168457,505796,500389,255978,897465,276552,950431,256552,539099,365635,251840,391911,399208,161839,110388,555073,560501,315412,90758,88258,190432,779194,254372,633956,586211,651705,738769,219732,600514,109522,490826,663939,158317,593074,978715,163454,261582,219186,523158,551585,910767,158119,45213,657017,314879,897719,515491,779570,134230,156509,103823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]