SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436743 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436743 [ RunTime:0.003786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712474,85834,199491,511527,607252,359224,724428,581173,819366,676209,575612,266750,329029,345317,597751,182992,524086,226324,585689,508809,943742,248707,872556,141034,1013700,1021945,626048,305650,17987,124105,268413,509434,265504,767208,7152,589102,158174,465378,86616,297483,704627,607492,523953,15011,873906,247723,245765,367931,655270,379409,633436,697561,529857,695704,403536,1019780,797783,702194,195193,203731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]