SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001752s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539861 LIMIT 1 [ RunTime:0.003658s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539861 [ RunTime:0.002964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450275,542964,525971,554389,159939,793015,284998,140921,972585,771648,2424,336416,702452,70945,231805,369120,63759,491027,360071,1048238,678005,808073,980010,244549,819636,540131,686977,630283,733966,279600,383617,721357,882326,336833,791100,762645,786819,183171,982468,445481,1041766,874311,494488,695301,424035,455462,847386,101224,314327,4610,478818,144061,729095,216858,724165,562624,56870,49129,1013373,95268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]